<?php
namespace frontend\modules\Api\controllers;

use common\jobs\NewUserJob;
use common\models\AppSerial;
use common\models\SysSetting;
use common\models\Tally;
use common\models\TallyAccount;
use common\models\TallyCategory;
use common\models\TallyFuture;
use common\models\TallyRecord;
use common\models\TallyVipOrder;
use common\models\TestContent;
use common\models\User;
use common\services\AppleServices;
use common\services\DomainAuthService;
use common\services\DomainExtraConfigService;
use common\services\TallyArapService;
use common\services\TallyFutureServices;
use common\services\TallyRecordService;
use common\services\TallyService;
use frontend\modules\Api\services\CommonService;
use Yii;
use common\services\UserService;
use common\services\ToolService;
use yii\base\DynamicModel;
use yii\base\Exception;
use yii\base\InvalidConfigException;
use yii\helpers\ArrayHelper;
use Qcloud\Sms\SmsSingleSender;

/**
 * Class PublicController
 * @package frontend\modules\Api\controllers
 */
class PublicController extends ApiController
{
    /**
     * @var bool
     * 禁用csrf验证
     */
    public $enableCsrfValidation = false;


    /**
     * @throws InvalidConfigException
     */
    public function actionAddRecordFor(){


//        $data = [
//            '18239925761',
//            '18937285791',
//            '13838372267',
//            '13253614321',
//            '15890077959',
//            '13613838596',
//            '15238339833',
//            '13276906310',
//            '15838753692',
//            '15803845707',
//            '18637187356',
//            '13903712213',
//        ];

        UserService::register([
            'mobile' => '15801845707',
            'password' => '123456',
            'password2' => '123456',
        ]);


//        foreach ($data as $value){
//            $user = User::find()->where([
//                'mobile'=>$value
//            ])->one();
//            $user->vip_status = 1;
//            $user->save();
//        }










//        foreach ($data as $value){
//            $insertUid     = UserService::register([
//                'mobile' => $value,
//                'password' => '123456',
//                'password2' => '123456',
//            ]);
//        }




        return;



        set_time_limit(10000000);
        $dateR = '2023-11-30';
        $timeR = '23:59:59';
        $tally_time = '2023-11-30 23:59:59';

        $str = '[{"store_id":361,"project_name":"桐柏全季","category_id":1194,"amount":211000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:48","timeR":"15:42:48","type":20,"project_id":175,"memo":"11.21日付不锈钢款"},{"project_id":114,"category_id":1600,"amount":1683,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":180,"category_id":1647,"amount":22239,"account_id":68,"cate":"A采家具-客房固装家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":175,"category_id":1610,"amount":29600,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":175,"category_id":1608,"amount":15018.51,"account_id":68,"cate":"A采小项-指示牌","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":168,"category_id":1612,"amount":4299.65,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":173,"category_id":1610,"amount":29600,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":173,"category_id":1608,"amount":20913.25,"account_id":68,"cate":"A采小项-指示牌","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:49","timeR":"15:42:49","type":20,"memo":"11.21日付A采材料款"},{"project_id":181,"category_id":1656,"amount":31250,"account_id":68,"cate":"A采家具-客房固定家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"memo":"11.21日付A采材料款"},{"store_id":369,"project_name":"民生西街全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":113,"memo":"11.22日付泥工施工款"},{"store_id":369,"project_name":"中牟上东里全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":168,"memo":"11.22日付泥工施工款"},{"store_id":378,"project_name":"洛阳美居","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":182,"memo":"11.22日付拆除施工款"},{"store_id":182,"project_name":"洛阳美居","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":182,"memo":"11.22日付泥工施工款"},{"store_id":363,"project_name":"桐柏全季","category_id":1194,"amount":150000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":175,"memo":"11.22日付雨棚施工款"},{"store_id":352,"project_name":"南阳漫心","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":114,"memo":"11.22日付泥工施工款"},{"store_id":377,"project_name":"中牟上东里全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:50","timeR":"15:42:50","type":20,"project_id":168,"memo":"11.22日付水电施工款"},{"store_id":376,"project_name":"中牟上东里全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"project_id":168,"memo":"11.22日付木工施工款"},{"store_id":372,"project_name":"中牟上东里全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"project_id":168,"memo":"11.22日付油漆施工款"},{"store_id":352,"project_name":"中牟上东里全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"project_id":168,"memo":"11.22日付泥工施工款"},{"category_id":1213,"amount":15,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"memo":"11.22日付吴赛戈过路费"},{"project_id":164,"category_id":1209,"amount":4860,"account_id":68,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"memo":"11.22日付办公室电脑款"},{"project_id":164,"category_id":1213,"amount":170.38,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"memo":"11.22日付程飞洛阳项目勘测费"},{"project_id":114,"category_id":1609,"amount":6165.2,"account_id":68,"cate":"A采小项-易耗品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:51","timeR":"15:42:51","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1617,"amount":25950,"account_id":68,"cate":"A采小项-香氛","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1610,"amount":910,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1635,"amount":7715,"account_id":68,"cate":"A采餐厅厨房用品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1600,"amount":6687,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"memo":"11.23日付A采材料款"},{"store_id":472,"project_name":"南阳漫心","category_id":1194,"amount":22500,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"project_id":114,"memo":"11.23日付电器轿厢款"},{"project_id":114,"category_id":1609,"amount":5743,"account_id":68,"cate":"A采小项-易耗品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1612,"amount":628.5,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:52","timeR":"15:42:52","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1619,"amount":72,"account_id":68,"cate":"A采餐厅厨房用品-餐厅用品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1628,"amount":15130,"account_id":68,"cate":"A采小项-甲醛","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1610,"amount":1080,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1620,"amount":1125,"account_id":68,"cate":"A采小项-客房摆件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":114,"category_id":1206,"amount":1251,"account_id":68,"cate":"A采床垫、窗帘、布草","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":167,"category_id":1600,"amount":12008,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":175,"category_id":1600,"amount":87984,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:53","timeR":"15:42:53","type":20,"memo":"11.23日付A采材料款"},{"project_id":175,"category_id":1612,"amount":367878,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:54","timeR":"15:42:54","type":20,"memo":"11.23日付A采材料款"},{"store_id":413,"project_name":"桐柏全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:54","timeR":"15:42:54","type":20,"project_id":175,"memo":"11.23日付空调热水施工款"},{"project_id":173,"category_id":1600,"amount":152900,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:54","timeR":"15:42:54","type":20,"memo":"11.24日付A采材料款"},{"store_id":474,"project_name":"方城汉庭","category_id":1194,"amount":124000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:54","timeR":"15:42:54","type":20,"project_id":115,"memo":"11.24日付淋浴房款"},{"project_id":115,"category_id":1610,"amount":6320,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:55","timeR":"15:42:55","type":20,"memo":"11.24日付A采材料款"},{"project_id":115,"category_id":1647,"amount":518790,"account_id":68,"cate":"A采家具-客房固装家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:55","timeR":"15:42:55","type":20,"memo":"11.24日付A采材料款"},{"project_id":115,"category_id":1622,"amount":157000,"account_id":68,"cate":"A采家具-公区活动家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:55","timeR":"15:42:55","type":20,"memo":"11.24日付A采材料款"},{"project_id":115,"category_id":1600,"amount":12946.5,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:55","timeR":"15:42:55","type":20,"memo":"11.24日付A采材料款"},{"store_id":497,"project_name":"南阳漫心","category_id":1194,"amount":58000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:55","timeR":"15:42:55","type":20,"project_id":114,"memo":"11.24日付会议室显示屏款"},{"project_id":115,"category_id":1611,"amount":19881,"account_id":68,"cate":"A采小项-工装","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"memo":"11.24日付A采材料款"},{"project_id":115,"category_id":1610,"amount":208526,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"memo":"11.24日付A采材料款"},{"project_id":115,"category_id":1206,"amount":7014,"account_id":68,"cate":"A采床垫、窗帘、布草","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"memo":"11.24日付A采材料款"},{"project_id":115,"category_id":1657,"amount":26397,"account_id":68,"cate":"A采餐厅厨房用品-厨房用品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"memo":"11.24日付A采材料款"},{"store_name":"陈鹏帅","category_id":1197,"amount":11646,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"store_id":229,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"袁二圈","category_id":1197,"amount":7050,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"store_id":195,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"陈文鹏","category_id":1197,"amount":5611.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:56","timeR":"15:42:56","type":20,"store_id":206,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"徐圳杰","category_id":1197,"amount":9682.94,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":223,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"白铁群","category_id":1197,"amount":6085,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":196,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"任炯","category_id":1197,"amount":5646.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":217,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"季昌华","category_id":1197,"amount":13049.35,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":222,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"郑英杰","category_id":1197,"amount":10611.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":198,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"郑凯峰","category_id":1197,"amount":8681.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":192,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"申利盈","category_id":1197,"amount":9050,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:57","timeR":"15:42:57","type":20,"store_id":233,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"陈成龙","category_id":1197,"amount":8980,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"store_id":232,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"陆晓龙","category_id":1197,"amount":6954.55,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"store_id":230,"memo":"11.24日付10月份工资其他应付款"},{"store_name":"王明鉴","category_id":1197,"amount":12254.87,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"store_id":202,"memo":"11.24日付10月份工资其他应付款"},{"store_id":367,"project_name":"洛阳美居","category_id":1194,"amount":280000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"project_id":182,"memo":"11.25日付木工施工款"},{"store_id":352,"project_name":"洛阳美居","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"project_id":182,"memo":"11.25日付泥工施工款"},{"store_id":182,"project_name":"洛阳美居","category_id":1194,"amount":200000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"project_id":182,"memo":"11.25日付泥工施工款"},{"store_id":362,"project_name":"洛阳美居","category_id":1194,"amount":200000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:58","timeR":"15:42:58","type":20,"project_id":182,"memo":"11.25日付油漆施工款"},{"store_id":402,"project_name":"洛阳美居","category_id":1194,"amount":250000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"project_id":182,"memo":"11.25日付水电施工款"},{"store_name":"张建春","category_id":1197,"amount":8962.45,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"store_id":228,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"袁万香","category_id":1197,"amount":6549.75,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"store_id":212,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"袁运涛","category_id":1197,"amount":8803.97,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"store_id":197,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"刘赛博","category_id":1197,"amount":4480,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"store_id":445,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"李军","category_id":1197,"amount":10766.65,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"store_id":200,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"徐永亮","category_id":1197,"amount":5421.67,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:42:59","timeR":"15:42:59","type":20,"store_id":498,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"岳培庆","category_id":1197,"amount":9085,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"store_id":479,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"王文博","category_id":1197,"amount":3488.33,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"store_id":499,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"袁广民","category_id":1197,"amount":2356.67,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"store_id":500,"memo":"11.25日付10月份工资其他应付款"},{"store_name":"郑银龙","category_id":1197,"amount":603.33,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"store_id":501,"memo":"11.25日付10月份工资其他应付款"},{"project_id":114,"category_id":1613,"amount":80000,"account_id":68,"cate":"A采家具-公区固装家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"memo":"11.27日付A采材料款"},{"project_id":114,"category_id":1654,"amount":9980,"account_id":68,"cate":"A采智能弱电-智能","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"memo":"11.27日付拍照款"},{"project_id":114,"category_id":1622,"amount":302800,"account_id":68,"cate":"A采家具-公区活动家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"memo":"11.27日付A采材料款"},{"category_id":1219,"amount":77,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:00","timeR":"15:43:00","type":20,"memo":"11.27日付焦佳快递费"},{"project_id":164,"category_id":1209,"amount":209.8,"account_id":68,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"memo":"11.27日付程飞测距仪费"},{"project_id":164,"category_id":1213,"amount":319.3,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"memo":"11.27日付左磊磊濮阳项目差旅费"},{"project_id":164,"category_id":1213,"amount":1648.66,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"memo":"11.27日付蒋旭焱报销差旅费"},{"project_id":168,"category_id":1658,"amount":990,"account_id":68,"cate":"中牟上东里全季","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"memo":"11.29日付A采材料款"},{"store_id":502,"project_name":"洛阳美居","category_id":1194,"amount":9920,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"project_id":182,"memo":"11.29日付A采材料款"},{"project_id":175,"category_id":1623,"amount":10217.52,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"memo":"11.29日付A采材料款"},{"project_id":185,"category_id":1623,"amount":14976,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:01","timeR":"15:43:01","type":20,"memo":"11.29日付A采材料款"},{"project_id":114,"category_id":1600,"amount":337,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"memo":"11.29日付A采材料款"},{"project_id":175,"category_id":1612,"amount":1186,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"memo":"11.29日付A采材料款"},{"project_id":168,"category_id":1600,"amount":61201.38,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"memo":"11.29日付A采材料款"},{"project_id":115,"category_id":1600,"amount":71501.65,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"memo":"11.29日付A采材料款"},{"store_name":"季兵","category_id":1197,"amount":15231.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"store_id":204,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"袁留魁","category_id":1197,"amount":5068.69,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"store_id":174,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"焦佳","category_id":1197,"amount":3764.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:02","timeR":"15:43:02","type":20,"store_id":218,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"侯盼茹","category_id":1197,"amount":6000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":224,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"蒋正华","category_id":1197,"amount":4000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":76,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"郑彬彬","category_id":1197,"amount":4131.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":213,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"付浩阔","category_id":1197,"amount":1066.67,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":503,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"任蕊峰","category_id":1197,"amount":1600,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":504,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"高亮","category_id":1197,"amount":2800,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":505,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"钟曙光","category_id":1197,"amount":6034.67,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:03","timeR":"15:43:03","type":20,"store_id":506,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"张利辉","category_id":1197,"amount":5000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"store_id":486,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"姜宗晨","category_id":1197,"amount":4885,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"store_id":245,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"左磊磊","category_id":1197,"amount":4715,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"store_id":242,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"程飞","category_id":1197,"amount":7552.42,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"store_id":239,"memo":"11.29日付10月份工资其他应付款"},{"project_id":115,"category_id":1623,"amount":960,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"memo":"11.29日付A采材料款"},{"project_id":115,"category_id":1610,"amount":1175,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"memo":"11.29日付A采材料款"},{"project_id":168,"category_id":1230,"amount":71.89,"account_id":68,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:04","timeR":"15:43:04","type":20,"memo":"11.29日付侯盼茹工地核量打车费"},{"project_id":114,"category_id":1611,"amount":32085,"account_id":68,"cate":"A采小项-工装","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"memo":"11.230日付A采材料款"},{"store_id":507,"project_name":"二七中原路全季","category_id":1194,"amount":4682.88,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"project_id":173,"memo":"11.30日付楼梯间钢制门款"},{"project_id":114,"category_id":1608,"amount":3020,"account_id":68,"cate":"A采小项-指示牌","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"memo":"11.30日付A采材料款"},{"project_id":175,"category_id":1600,"amount":3576.96,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"memo":"11.30日付A采材料款"},{"project_id":180,"category_id":1600,"amount":91416,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1609,"amount":9917.6,"account_id":68,"cate":"A采小项-易耗品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1610,"amount":1015,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:05","timeR":"15:43:05","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1612,"amount":3285.2,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1623,"amount":3796.7,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1622,"amount":10480,"account_id":68,"cate":"A采家具-公区活动家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1609,"amount":18701.92,"account_id":68,"cate":"A采小项-易耗品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1610,"amount":52933,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1619,"amount":14514.22,"account_id":68,"cate":"A采餐厅厨房用品-餐厅用品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1600,"amount":11075.2,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":115,"category_id":1609,"amount":18896.56,"account_id":68,"cate":"A采小项-易耗品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:06","timeR":"15:43:06","type":20,"memo":"11.30日付A采材料款"},{"project_id":182,"category_id":1604,"amount":23311.07,"account_id":68,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:07","timeR":"15:43:07","type":20,"memo":"11.30日付材料款"},{"store_id":508,"project_name":"桐柏全季","category_id":1194,"amount":30000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:07","timeR":"15:43:07","type":20,"project_id":175,"memo":"11.30日付外窗施工款"},{"store_id":421,"project_name":"桐柏全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:07","timeR":"15:43:07","type":20,"project_id":175,"memo":"11.30日付泥工施工款"},{"store_id":367,"project_name":"桐柏全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:07","timeR":"15:43:07","type":20,"project_id":175,"memo":"11.30日付木工施工款"},{"store_id":369,"project_name":"桐柏全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:07","timeR":"15:43:07","type":20,"project_id":175,"memo":"11.30日付泥工施工款"},{"store_id":352,"project_name":"黄河路全季","category_id":1194,"amount":80000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:07","timeR":"15:43:07","type":20,"project_id":180,"memo":"11.30日付泥工施工款"},{"store_id":378,"project_name":"黄河路全季","category_id":1194,"amount":80000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"project_id":180,"memo":"11.30日付拆除施工款"},{"store_id":369,"project_name":"南阳漫心","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"project_id":114,"memo":"11.30日付泥工施工款"},{"store_id":451,"project_name":"二七中原路全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"project_id":173,"memo":"11.30日付木工施工款"},{"store_id":362,"project_name":"二七中原路全季","category_id":1194,"amount":80000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"project_id":173,"memo":"11.30日付油漆施工款"},{"store_id":369,"project_name":"二七中原路全季","category_id":1194,"amount":120000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"project_id":173,"memo":"11.30日付泥工施工款"},{"store_id":425,"project_name":"新乡平原路汉庭","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"project_id":167,"memo":"11.30日付木工施工款"},{"project_id":168,"category_id":1659,"amount":25000,"account_id":68,"cate":"总部管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:08","timeR":"15:43:08","type":20,"memo":"11.30日付项目管理费"},{"project_id":115,"category_id":1659,"amount":25000,"account_id":68,"cate":"总部管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:09","timeR":"15:43:09","type":20,"memo":"11.30日付项目管理费"},{"project_id":174,"category_id":1659,"amount":25000,"account_id":68,"cate":"总部管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:09","timeR":"15:43:09","type":20,"memo":"11.30日付项目管理费"},{"project_id":169,"category_id":1659,"amount":25000,"account_id":68,"cate":"总部管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:09","timeR":"15:43:09","type":20,"memo":"11.30日付项目管理费"},{"project_id":181,"category_id":1659,"amount":25000,"account_id":68,"cate":"总部管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:09","timeR":"15:43:09","type":20,"memo":"11.30日付项目管理费"},{"store_name":"袁福君","category_id":1191,"amount":60000,"account_id":null,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:09","timeR":"15:43:09","type":10,"store_id":23,"memo":"11.16日洛阳中州西路全季回款"},{"project_name":"洛阳中州西路全季","category_id":1194,"amount":360000,"account_id":null,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:43:09","timeR":"15:43:09","type":10,"project_id":185,"memo":"洛阳中州西路全季回款"},{"project_id":181,"category_id":1623,"amount":-12929,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:30","timeR":"15:37:30","type":20,"memo":"长垣汉庭换气扇退款"},{"project_name":"驻马店全季","category_id":1194,"amount":200000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:30","timeR":"15:37:30","type":10,"project_id":163,"memo":"驻马店全季装修尾款"},{"project_name":"南阳你好","category_id":1194,"amount":1400000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:30","timeR":"15:37:30","type":10,"project_id":184,"memo":"南阳你好回款"},{"project_name":"桐柏全季","category_id":1194,"amount":550000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":10,"project_id":175,"memo":"桐柏全季回款"},{"project_name":"二七中原路全季","category_id":1194,"amount":800000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":10,"project_id":173,"memo":"二七中原路全季回款"},{"project_id":184,"category_id":1623,"amount":11454,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付A采材料款"},{"project_id":114,"category_id":1612,"amount":3171,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付A采材料款"},{"category_id":1652,"amount":10300,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付安全帽、马甲款"},{"category_id":1209,"amount":1900,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付焦佳成品保护条费"},{"project_id":168,"category_id":1230,"amount":58.93,"account_id":68,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付侯盼茹项目核量打车费"},{"category_id":1213,"amount":317,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付袁总叶县至太康加油费"},{"project_id":164,"category_id":1209,"amount":452,"account_id":68,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:31","timeR":"15:37:31","type":20,"memo":"11.1日付焦佳南阳桐柏打印图纸费"},{"project_id":164,"category_id":1213,"amount":4096,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:32","timeR":"15:37:32","type":20,"memo":"11.1日付袁总兰州考察项目差旅费"},{"project_id":164,"category_id":1244,"amount":4400,"account_id":68,"cate":"业务招待费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:32","timeR":"15:37:32","type":20,"memo":"11.1日付袁总华住送礼"},{"store_name":"季兵","category_id":1197,"amount":8031.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:32","timeR":"15:37:32","type":20,"store_id":204,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"袁留魁","category_id":1197,"amount":5068.69,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:32","timeR":"15:37:32","type":20,"store_id":174,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"焦佳","category_id":1197,"amount":3498.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:32","timeR":"15:37:32","type":20,"store_id":218,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"侯盼茹","category_id":1197,"amount":6000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:32","timeR":"15:37:32","type":20,"store_id":224,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"蒋正华","category_id":1197,"amount":3857,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":76,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"郑彬彬","category_id":1197,"amount":4131.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":213,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"陈鹏帅","category_id":1197,"amount":10314,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":229,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"袁二圈","category_id":1197,"amount":7015,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":195,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"陈文鹏","category_id":1197,"amount":5611.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":206,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"徐圳杰","category_id":1197,"amount":9681.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":223,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"白铁群","category_id":1197,"amount":6050,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:33","timeR":"15:37:33","type":20,"store_id":196,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"任炯","category_id":1197,"amount":5611.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:34","timeR":"15:37:34","type":20,"store_id":217,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"季昌华","category_id":1197,"amount":8435.65,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:34","timeR":"15:37:34","type":20,"store_id":222,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"郑英杰","category_id":1197,"amount":10646.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:34","timeR":"15:37:34","type":20,"store_id":198,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"郑凯峰","category_id":1197,"amount":8646.36,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:34","timeR":"15:37:34","type":20,"store_id":192,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"申利盈","category_id":1197,"amount":8860.6,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:34","timeR":"15:37:34","type":20,"store_id":233,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"陈成龙","category_id":1197,"amount":8860.6,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:34","timeR":"15:37:34","type":20,"store_id":232,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"张利辉","category_id":1197,"amount":2850,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"store_id":486,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"姜宗晨","category_id":1197,"amount":6641,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"store_id":245,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"左磊磊","category_id":1197,"amount":5859,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"store_id":242,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"程飞","category_id":1197,"amount":6424.48,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"store_id":239,"memo":"11.2日付9月份工资其他应付款"},{"project_id":180,"category_id":1623,"amount":10944,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"memo":"11.3日付A采材料款"},{"store_id":469,"project_name":"黄河路全季","category_id":1194,"amount":90000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"project_id":180,"memo":"11.3日付窗户款"},{"project_id":175,"category_id":1600,"amount":10062.5,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:35","timeR":"15:37:35","type":20,"memo":"11.3日付A采材料款"},{"project_id":115,"category_id":1600,"amount":4572,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"memo":"11.3日付A采材料款"},{"store_name":"车贷分期","category_id":1197,"amount":4007.59,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"store_id":487,"memo":"11.3日还车贷其他应付款"},{"project_id":164,"category_id":1213,"amount":1900.98,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"memo":"11.3日付王文霞总部开会打车费、餐费"},{"project_id":164,"category_id":1209,"amount":5100,"account_id":68,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"memo":"11.3日付上海办公室宽带费"},{"category_id":1652,"amount":5390,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"memo":"11.3日付王珍珍安全指示牌费"},{"store_name":"岳培庆","category_id":1197,"amount":4832,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"store_id":479,"memo":"11.3日付9月份工资其他应付款"},{"project_id":173,"category_id":1610,"amount":112974,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:36","timeR":"15:37:36","type":20,"memo":"11.4日付A采材料款"},{"project_id":180,"category_id":1610,"amount":243346,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"memo":"11.4日付A采材料款"},{"store_id":419,"project_name":"中牟上东里全季","category_id":1194,"amount":7800,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"project_id":168,"memo":"11.4日付水泥款"},{"category_id":1213,"amount":333.79,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"memo":"11.4日付袁总高速过路费"},{"project_id":184,"category_id":1604,"amount":31789.34,"account_id":68,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"memo":"11.7日付A采材料款"},{"project_id":184,"category_id":1602,"amount":23043.1,"account_id":68,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"memo":"11.7日付A采材料款"},{"project_id":115,"category_id":1612,"amount":55702,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"memo":"11.7日付A采材料款"},{"project_id":115,"category_id":1612,"amount":96180,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:37","timeR":"15:37:37","type":20,"memo":"11.7日付A采材料款"},{"project_id":182,"category_id":1218,"amount":300000,"account_id":68,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"memo":"11.7日付李洋20万、秦扬懿10万业务费"},{"project_id":114,"category_id":1600,"amount":11507,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"memo":"11.7日付A采材料款"},{"project_id":114,"category_id":1206,"amount":142580,"account_id":68,"cate":"A采床垫、窗帘、布草","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"memo":"11.7日付A采材料款"},{"store_id":441,"project_name":"南阳漫心","category_id":1194,"amount":564844,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"project_id":114,"memo":"11.7日付家具款"},{"store_id":361,"project_name":"中牟上东里全季","category_id":1194,"amount":200000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"project_id":168,"memo":"11.7日付不锈钢款"},{"project_id":168,"category_id":1600,"amount":19267,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"memo":"11.7日付A采材料款"},{"project_id":180,"category_id":1600,"amount":30598.8,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:38","timeR":"15:37:38","type":20,"memo":"11.7日付A采材料款"},{"project_id":175,"category_id":1600,"amount":88000,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付A采材料款"},{"project_id":115,"category_id":1653,"amount":15951.2,"account_id":68,"cate":"A采小项","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付A采材料款"},{"project_id":182,"category_id":1600,"amount":17503,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付A采材料款"},{"project_id":173,"category_id":1600,"amount":76471.2,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付A采材料款"},{"project_id":175,"category_id":1600,"amount":17024,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付A采材料款"},{"project_id":164,"category_id":1213,"amount":172.15,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付任蕊峰兰州出差打车费"},{"project_id":164,"category_id":1213,"amount":31.96,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:39","timeR":"15:37:39","type":20,"memo":"11.7日付程飞重庆出差打车费"},{"category_id":1223,"amount":1507.97,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"memo":"11.8日付银行手续费"},{"store_id":465,"project_name":"洛阳美居","category_id":1194,"amount":570205,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"project_id":182,"memo":"11.8日付智能款"},{"store_id":441,"project_name":"南阳漫心","category_id":1194,"amount":285000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"project_id":114,"memo":"11.8日付家具款"},{"store_id":488,"project_name":"黄河路全季","category_id":1194,"amount":80000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"project_id":180,"memo":"11.8日付加固施工款"},{"project_id":175,"category_id":1610,"amount":56001,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"memo":"11.8日付A采材料款"},{"project_id":115,"category_id":1623,"amount":4500,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"memo":"11.8日付A采材料款"},{"project_id":168,"category_id":1600,"amount":23780,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:40","timeR":"15:37:40","type":20,"memo":"11.8日付A采材料款"},{"project_id":114,"category_id":1623,"amount":1041.9,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"memo":"11.8日付A采材料款"},{"store_id":489,"project_name":"黄河路全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"project_id":180,"memo":"11.8日付墙板定金"},{"store_id":490,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"project_id":175,"memo":"11.10日付小米智能定金"},{"store_id":392,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"project_id":175,"memo":"11.10日付台盆定金"},{"store_id":491,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"project_id":175,"memo":"11.10日付五金定金"},{"store_id":492,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"project_id":175,"memo":"11.10日付马桶定金"},{"store_id":490,"project_name":"二七中原路全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:41","timeR":"15:37:41","type":20,"project_id":173,"memo":"11.10日付小米智能定金"},{"store_id":392,"project_name":"二七中原路全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:42","timeR":"15:37:42","type":20,"project_id":173,"memo":"11.10日付台盆定金"},{"store_id":491,"project_name":"二七中原路全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:42","timeR":"15:37:42","type":20,"project_id":173,"memo":"11.10日付五金定金"},{"store_id":492,"project_name":"二七中原路全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"project_id":173,"memo":"11.10日付马桶定金"},{"project_id":114,"category_id":1623,"amount":1428,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"memo":"11.10日付A采材料款"},{"project_id":114,"category_id":1622,"amount":32890,"account_id":68,"cate":"A采家具-公区活动家具","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"memo":"11.10日付A采材料款"},{"project_id":115,"category_id":1610,"amount":33255,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"memo":"11.10日付A采材料款"},{"project_id":115,"category_id":1612,"amount":5276,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"memo":"11.10日付A采材料款"},{"project_id":115,"category_id":1636,"amount":92086,"account_id":68,"cate":"A采智能弱电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"memo":"11.10日付A采材料款"},{"project_id":115,"category_id":1636,"amount":59978.5,"account_id":68,"cate":"A采智能弱电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:43","timeR":"15:37:43","type":20,"memo":"11.10日付A采材料款"},{"project_name":"二七中原路全季","category_id":1194,"amount":2000000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:44","timeR":"15:37:44","type":10,"project_id":173,"memo":"二七中原路全季回款"},{"project_name":"洛阳美居","category_id":1194,"amount":2417253,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:44","timeR":"15:37:44","type":10,"project_id":182,"memo":"洛阳美居回款"},{"project_name":"中牟上东里全季","category_id":1194,"amount":2325000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:44","timeR":"15:37:44","type":10,"project_id":168,"memo":"中牟全季回款"},{"project_id":164,"category_id":1209,"amount":8360,"account_id":68,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:44","timeR":"15:37:44","type":20,"memo":"11.10日付打印机一台、投影仪一台支架一个"},{"project_id":164,"category_id":1209,"amount":240.8,"account_id":68,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:44","timeR":"15:37:44","type":20,"memo":"11.10日付任蕊峰桐柏全季图纸打印费"},{"project_id":182,"category_id":1602,"amount":37000,"account_id":68,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"memo":"11.11日付电箱款"},{"store_id":361,"project_name":"南阳漫心","category_id":1194,"amount":300000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"project_id":114,"memo":"11.11日付不锈钢款"},{"project_id":182,"category_id":1218,"amount":200000,"account_id":68,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"memo":"11.13日付河南豫平隆酒店业务费"},{"category_id":1209,"amount":340,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"memo":"11.13日付任蕊峰办公用品费"},{"project_id":164,"category_id":1213,"amount":263.98,"account_id":68,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"memo":"11.13日付程飞濮阳项目勘测车费"},{"store_name":"代扣个人所得税","category_id":1197,"amount":1086.04,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"store_id":237,"memo":"11.13日付个人所得税其他应付款"},{"category_id":1220,"amount":16008.45,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"memo":"11.13日付社保单位部分"},{"store_name":"社保个人费用","category_id":1197,"amount":6372.71,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:45","timeR":"15:37:45","type":20,"store_id":238,"memo":"11.13日付社保个人部分其他应付款"},{"category_id":1221,"amount":81542.51,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"memo":"11.13日付增值税"},{"category_id":1209,"amount":3588,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"memo":"11.14日付办公室光纤网费"},{"project_id":173,"category_id":1600,"amount":96535,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"memo":"11.14日付A采材料款"},{"project_id":173,"category_id":1610,"amount":295,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"memo":"11.14日付A采材料款"},{"store_id":384,"project_name":"二七中原路全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"project_id":173,"memo":"11.14日付活动家具定金"},{"store_id":494,"project_name":"二七中原路全季","category_id":1194,"amount":290000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"project_id":173,"memo":"11.14日付家具款"},{"project_id":182,"category_id":1601,"amount":480,"account_id":68,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:46","timeR":"15:37:46","type":20,"memo":"11.14日付材料款"},{"project_id":182,"category_id":1604,"amount":34320,"account_id":68,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付材料款"},{"project_id":182,"category_id":1229,"amount":7200,"account_id":68,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付材料款"},{"project_id":182,"category_id":1600,"amount":15000,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付A采材料款"},{"project_id":180,"category_id":1600,"amount":289443,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付A采材料款"},{"project_id":168,"category_id":1623,"amount":28127,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付A采材料款"},{"project_id":115,"category_id":1654,"amount":2296,"account_id":68,"cate":"A采智能弱电-智能","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付A采材料款"},{"project_id":115,"category_id":1600,"amount":4572,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:47","timeR":"15:37:47","type":20,"memo":"11.14日付A采材料款"},{"project_id":175,"category_id":1610,"amount":182,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:48","timeR":"15:37:48","type":20,"memo":"11.14日付A采材料款"},{"project_id":175,"category_id":1600,"amount":38869,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:48","timeR":"15:37:48","type":20,"memo":"11.14日付A采材料款"},{"store_id":494,"project_name":"桐柏全季","category_id":1194,"amount":163500,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:48","timeR":"15:37:48","type":20,"project_id":175,"memo":"11.14日付家具款"},{"store_id":384,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:48","timeR":"15:37:48","type":20,"project_id":175,"memo":"11.14日付活动家具定金"},{"project_id":114,"category_id":1610,"amount":4560,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:48","timeR":"15:37:48","type":20,"memo":"11.15日付A采材料款"},{"project_id":114,"category_id":1654,"amount":31879,"account_id":68,"cate":"A采智能弱电-智能","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:48","timeR":"15:37:48","type":20,"memo":"11.15日付A采材料款"},{"project_id":114,"category_id":1612,"amount":1560,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"memo":"11.15日付A采材料款"},{"store_id":413,"project_name":"长垣汉庭","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"project_id":181,"memo":"11.15日付热水施工款"},{"store_id":413,"project_name":"桐柏全季","category_id":1194,"amount":100000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"project_id":175,"memo":"11.15日付空调热水施工款"},{"project_id":182,"category_id":1230,"amount":11381,"account_id":68,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"memo":"11.15日付袁留魁洛阳美居验收买烟、餐费"},{"category_id":1244,"amount":782,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"memo":"11.15日付袁留魁招待太康投资人餐费"},{"category_id":1242,"amount":29800,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"memo":"11.16日付培训费"},{"category_id":1224,"amount":780.8,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"memo":"11.16日付办公室10月份水电费"},{"category_id":1209,"amount":157.4,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:49","timeR":"15:37:49","type":20,"memo":"11.16日付高亮购买出库登记本费"},{"store_id":495,"project_name":"洛阳美居","category_id":1194,"amount":2000000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"project_id":182,"memo":"11.17日付家具款"},{"project_id":175,"category_id":1612,"amount":17070,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"memo":"11.17日付A采材料款"},{"project_id":169,"category_id":1600,"amount":8511.5,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"memo":"11.17日付A采材料款"},{"project_id":173,"category_id":1600,"amount":15110,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"memo":"11.17日付A采材料款"},{"project_id":114,"category_id":1600,"amount":16248,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"memo":"11.17日付A采材料款"},{"project_id":114,"category_id":1623,"amount":4146.24,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"memo":"11.17日付A采材料款"},{"project_id":182,"category_id":1600,"amount":269437.5,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:50","timeR":"15:37:50","type":20,"memo":"11.17日付A采材料款"},{"project_id":182,"category_id":1600,"amount":27094,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:51","timeR":"15:37:51","type":20,"memo":"11.17日付A采材料款"},{"project_id":115,"category_id":1206,"amount":38964,"account_id":68,"cate":"A采床垫、窗帘、布草","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:51","timeR":"15:37:51","type":20,"memo":"11.17日付A采材料款"},{"project_id":115,"category_id":1623,"amount":37922,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:51","timeR":"15:37:51","type":20,"memo":"11.17日付A采材料款"},{"project_id":115,"category_id":1610,"amount":29600,"account_id":68,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:51","timeR":"15:37:51","type":20,"memo":"11.17日付A采材料款"},{"project_id":115,"category_id":1623,"amount":11036,"account_id":68,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:51","timeR":"15:37:51","type":20,"memo":"11.17日付A采材料款"},{"project_id":115,"category_id":1206,"amount":181035.05,"account_id":68,"cate":"A采床垫、窗帘、布草","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:51","timeR":"15:37:51","type":20,"memo":"11.17日付A采材料款"},{"project_id":115,"category_id":1600,"amount":8088.8,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"memo":"11.17日付A采材料款"},{"store_id":496,"project_name":"方城汉庭","category_id":1194,"amount":155637,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"project_id":115,"memo":"11.17日付家具款"},{"store_id":471,"project_name":"洛阳美居","category_id":1194,"amount":50000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"project_id":182,"memo":"11.18日付石膏线款"},{"project_id":114,"category_id":1600,"amount":2527,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"memo":"11.18日付A采材料款"},{"project_id":114,"category_id":1655,"amount":4000,"account_id":68,"cate":"A采厨房设备","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"memo":"11.18日付A采材料款"},{"project_id":175,"category_id":1600,"amount":1700,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"memo":"11.20日付A采材料款"},{"project_id":114,"category_id":1612,"amount":2514,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:52","timeR":"15:37:52","type":20,"memo":"11.20日付A采材料款"},{"project_id":181,"category_id":1600,"amount":3800,"account_id":68,"cate":"基装A采建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":20,"memo":"11.20日付A采材料款"},{"category_id":1214,"amount":2805,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":20,"memo":"11.20日付小蒋车辆维修费（90368）"},{"category_id":1219,"amount":581.9,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":20,"memo":"11.20日付小蒋快递费"},{"category_id":1244,"amount":1544,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":20,"memo":"11.20日付小蒋招待崔总餐费"},{"category_id":1219,"amount":450.76,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":20,"memo":"11.20日付小蒋快递费"},{"project_id":114,"category_id":1612,"amount":-238,"account_id":68,"cate":"基装A采洁具五金件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":20,"memo":"南阳漫心台下盆差价退款"},{"project_name":"洛阳美居","category_id":1194,"amount":1100000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":10,"project_id":182,"memo":"洛阳美居回款"},{"project_name":"二七中原路全季","category_id":1194,"amount":1650000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:37:53","timeR":"15:37:53","type":10,"project_id":173,"memo":"二七中原路全季回款"},{"store_id":355,"project_name":"南阳漫心","category_id":1194,"amount":59500,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:54","timeR":"15:37:54","type":20,"project_id":114,"memo":"11.21日付石材款"},{"store_id":355,"project_name":"南阳你好","category_id":1194,"amount":19500,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:54","timeR":"15:37:54","type":20,"project_id":184,"memo":"11.21日付石材款"},{"store_id":355,"project_name":"中牟上东里全季","category_id":1194,"amount":25900,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:54","timeR":"15:37:54","type":20,"project_id":168,"memo":"11.21日付石材款"},{"store_id":355,"project_name":"方城汉庭","category_id":1194,"amount":21900,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:54","timeR":"15:37:54","type":20,"project_id":115,"memo":"11.21日付石材款"},{"store_id":355,"project_name":"高新区海友","category_id":1194,"amount":15500,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:54","timeR":"15:37:54","type":20,"project_id":169,"memo":"11.21日付石材款"},{"store_id":355,"project_name":"长垣汉庭","category_id":1194,"amount":102000,"account_id":68,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:37:54","timeR":"15:37:54","type":20,"project_id":181,"memo":"11.21日付石材款"},{"project_name":"方城汉庭","category_id":1194,"amount":1450000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":10,"project_id":115,"memo":"方城汉庭回款"},{"project_name":"高新区海友","category_id":1194,"amount":300000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":10,"project_id":169,"memo":"高新区海友回款"},{"project_name":"新乡平原路汉庭","category_id":1194,"amount":300000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":10,"project_id":167,"memo":"新乡汉庭回款"},{"project_name":"南阳漫心","category_id":1194,"amount":1000000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":10,"project_id":114,"memo":"南阳漫心回款"},{"store_name":"社保个人费用","category_id":1197,"amount":1272.33,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":20,"store_id":238,"memo":"周雪敏社保转入"},{"store_name":"社保个人费用","category_id":1197,"amount":1272.33,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":20,"store_id":238,"memo":"周雪敏社保转入","is_gua":true},{"store_name":"袁福君","category_id":1191,"amount":20000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":10,"store_id":23,"memo":"11.1日微信网上支付"},{"project_id":167,"category_id":1229,"amount":1071,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:12","timeR":"15:31:12","type":20,"memo":"11.1日付合页款"},{"store_name":"王进有","category_id":1197,"amount":13190,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":20,"store_id":199,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"马静","category_id":1197,"amount":10000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":20,"store_id":205,"memo":"11.2日付9月份工资其他应付款"},{"store_name":"王文霞","category_id":1197,"amount":22000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":20,"store_id":240,"memo":"11.2日付9月份工资其他应付款"},{"store_id":212,"project_name":"二七中原路全季","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":20,"project_id":173,"memo":"11.2日付工地备用金"},{"project_id":164,"category_id":1209,"amount":33527,"account_id":70,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":20,"memo":"11.2日付程千宝购买电脑款"},{"project_id":164,"category_id":1213,"amount":652.5,"account_id":70,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":20,"memo":"11.2日付王文霞车票费"},{"store_name":"袁福君","category_id":1191,"amount":152,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:13","timeR":"15:31:13","type":10,"store_id":23,"memo":"11.2日微信网上支付"},{"store_id":362,"project_name":"洛阳美居","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:14","timeR":"15:31:14","type":20,"project_id":182,"memo":"11.3日付乳胶漆施工款"},{"store_id":370,"project_name":"高新区海友","category_id":1194,"amount":8000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:14","timeR":"15:31:14","type":20,"project_id":169,"memo":"11.3日付木地板施工款"},{"store_id":198,"project_name":"中牟上东里全季","category_id":1194,"amount":15000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:14","timeR":"15:31:14","type":20,"project_id":168,"memo":"11.3日付工地备用金"},{"store_id":198,"project_name":"中牟上东里全季","category_id":1194,"amount":7000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:14","timeR":"15:31:14","type":20,"project_id":168,"memo":"11.3日付侯帅垃圾清运费"},{"store_name":"项目奖金","category_id":1197,"amount":30000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:14","timeR":"15:31:14","type":20,"store_id":433,"memo":"11.3日付陈鹏帅预支项目奖金其他应付款"},{"store_name":"李军","category_id":1197,"amount":10000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:14","timeR":"15:31:14","type":20,"store_id":200,"memo":"11.3日还欠款其他应付款"},{"store_id":361,"project_name":"民生西街全季","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"project_id":113,"memo":"11.3日付不锈钢款"},{"project_id":164,"category_id":1218,"amount":20000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"memo":"11.3日付袁总洛阳美居业务费（朱伟涛）"},{"project_id":164,"category_id":1218,"amount":90000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"memo":"11.3日付朱晓伟洛阳美居业务费（代朱总收）"},{"store_id":363,"project_name":"中牟上东里全季","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"project_id":168,"memo":"11.3日付铝板施工款"},{"store_id":380,"project_name":"洛阳美居","category_id":1194,"amount":40000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"project_id":182,"memo":"11.3日付防水施工款"},{"store_id":182,"project_name":"洛阳美居","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"project_id":182,"memo":"11.3日付贴砖施工款"},{"store_id":361,"project_name":"高新区海友","category_id":1194,"amount":128500,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:15","timeR":"15:31:15","type":20,"project_id":169,"memo":"11.4日付不锈钢款"},{"store_name":"袁福君","category_id":1191,"amount":50000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:16","timeR":"15:31:16","type":10,"store_id":23,"memo":"11.6日转袁总民生卡"},{"project_id":173,"category_id":1648,"amount":28900,"account_id":70,"cate":"员工宿舍顶","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:16","timeR":"15:31:16","type":20,"memo":"11.7日付彩钢房费用"},{"store_id":223,"project_name":"方城汉庭","category_id":1194,"amount":15000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:16","timeR":"15:31:16","type":20,"project_id":115,"memo":"11.7日付工地备用金"},{"store_id":202,"project_name":"桐柏全季","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:16","timeR":"15:31:16","type":20,"project_id":175,"memo":"11.7日付工地备用金"},{"store_id":370,"project_name":"方城汉庭","category_id":1194,"amount":12600,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:16","timeR":"15:31:16","type":20,"project_id":115,"memo":"11.7日付木地板施工款"},{"store_id":206,"project_name":"洛阳美居","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:16","timeR":"15:31:16","type":20,"project_id":182,"memo":"11.7日付工地备用金"},{"store_id":192,"project_name":"新乡平原路汉庭","category_id":1194,"amount":30000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"project_id":167,"memo":"11.7日付工地备用金"},{"store_id":379,"project_name":"方城汉庭","category_id":1194,"amount":5000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"project_id":115,"memo":"11.7日付美缝施工款"},{"store_id":401,"project_name":"方城汉庭","category_id":1194,"amount":30000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"project_id":115,"memo":"11.7日付墙板施工款"},{"project_id":173,"category_id":1216,"amount":12780,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"memo":"11.7日付李利杰、李留福、孙福德、万山听9月份小工工资"},{"store_id":430,"project_name":"方城汉庭","category_id":1194,"amount":25000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"project_id":115,"memo":"11.7日付泥工施工款"},{"project_id":164,"category_id":1213,"amount":1100,"account_id":70,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"memo":"11.7日付程飞重庆项目高铁费"},{"store_id":206,"project_name":"洛阳美居","category_id":1194,"amount":29500,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:17","timeR":"15:31:17","type":20,"project_id":182,"memo":"11.8日付工地备用金"},{"store_id":229,"project_name":"洛阳美居","category_id":1194,"amount":4500,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:18","timeR":"15:31:18","type":20,"project_id":182,"memo":"11.8日付梁超兵垃圾清运费"},{"store_id":212,"project_name":"二七中原路全季","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:18","timeR":"15:31:18","type":20,"project_id":173,"memo":"11.9日付工地备用金"},{"store_id":451,"project_name":"二七中原路全季","category_id":1194,"amount":70000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:18","timeR":"15:31:18","type":20,"project_id":173,"memo":"11.9日付木工施工款"},{"store_id":378,"project_name":"二七中原路全季","category_id":1194,"amount":30000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:18","timeR":"15:31:18","type":20,"project_id":173,"memo":"11.9日付拆除施工款"},{"store_id":380,"project_name":"二七中原路全季","category_id":1194,"amount":40000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:18","timeR":"15:31:18","type":20,"project_id":173,"memo":"11.9日付防水施工款"},{"store_id":200,"project_name":"二七中原路全季","category_id":1194,"amount":13600,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:18","timeR":"15:31:18","type":20,"project_id":173,"memo":"11.9日付李淑权垃圾清运费"},{"store_id":372,"project_name":"南阳你好","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":20,"project_id":184,"memo":"11.9日付油漆施工款"},{"store_id":352,"project_name":"南阳你好","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":20,"project_id":184,"memo":"11.9日付泥工施工款"},{"store_name":"蒋旭焱","category_id":1197,"amount":4600,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":20,"store_id":475,"memo":"11.9日付9月份工资其他应付款"},{"project_name":"方城汉庭","category_id":1194,"amount":500000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":10,"project_id":115,"memo":"方城汉庭回款"},{"project_name":"新乡平原路汉庭","category_id":1194,"amount":300000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":10,"project_id":167,"memo":"新乡汉庭回款"},{"store_name":"金河全季","category_id":1191,"amount":110000,"account_id":68,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":10,"store_id":33,"memo":"全季酒店转入"},{"project_id":182,"category_id":1218,"amount":30000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:19","timeR":"15:31:19","type":20,"memo":"11.10日付刘工1万，陈东科2万（现金）"},{"store_id":380,"project_name":"方城汉庭","category_id":1194,"amount":5000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":20,"project_id":115,"memo":"11.10日付防水施工款"},{"store_id":362,"project_name":"二七中原路全季","category_id":1194,"amount":70000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":20,"project_id":173,"memo":"11.10日付油漆施工款"},{"store_name":"项目奖金","category_id":1197,"amount":91478,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":20,"store_id":433,"memo":"11.11日付办公室项目奖金其他应付款"},{"category_id":1216,"amount":3200,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":20,"memo":"11.11日付办公室项目奖金"},{"project_id":184,"category_id":1218,"amount":50000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":20,"memo":"11.12日付高总业务费（现金）"},{"store_name":"袁福君","category_id":1191,"amount":150000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":10,"store_id":23,"memo":"11.13日转袁总民生卡"},{"project_id":164,"category_id":1246,"amount":130000,"account_id":70,"cate":"外包设计费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:20","timeR":"15:31:20","type":20,"memo":"11.13日付张囡囡红旗路效果图2万，太康全套图纸11万"},{"project_id":164,"category_id":1242,"amount":25000,"account_id":70,"cate":"培训学习费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"memo":"11.13日付张囡囡星程考试方案"},{"project_id":184,"category_id":1218,"amount":120000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"memo":"11.13日付李本超业务费"},{"project_id":182,"category_id":1218,"amount":100000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"memo":"11.13日付秦扬懿业务费"},{"project_id":173,"category_id":1218,"amount":50000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"memo":"11.13日付秦扬懿业务费"},{"store_id":355,"project_name":"洛阳美居","category_id":1194,"amount":194000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"project_id":182,"memo":"11.13日付石材款"},{"project_id":164,"category_id":1213,"amount":50,"account_id":70,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"memo":"11.13日付程飞出差餐费"},{"store_id":370,"project_name":"中牟上东里全季","category_id":1194,"amount":17500,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:21","timeR":"15:31:21","type":20,"project_id":168,"memo":"11.13日付木地板施工款"},{"store_id":365,"project_name":"中牟上东里全季","category_id":1194,"amount":7600,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:22","timeR":"15:31:22","type":20,"project_id":168,"memo":"11.13日付玻璃施工款"},{"store_id":448,"project_name":"桐柏全季","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:22","timeR":"15:31:22","type":20,"project_id":175,"memo":"11.13日付钢结构施工款"},{"store_id":369,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:22","timeR":"15:31:22","type":20,"project_id":175,"memo":"11.13日付泥工施工款"},{"store_id":202,"project_name":"桐柏全季","category_id":1194,"amount":4530,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:22","timeR":"15:31:22","type":20,"project_id":175,"memo":"11.13日付安其东垃圾清运费"},{"store_id":379,"project_name":"新乡平原路汉庭","category_id":1194,"amount":15000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:22","timeR":"15:31:22","type":20,"project_id":167,"memo":"11.13日付美缝施工款"},{"store_id":476,"project_name":"新乡平原路汉庭","category_id":1194,"amount":3750,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:22","timeR":"15:31:22","type":20,"project_id":167,"memo":"11.13日付墙体堵洞施工款"},{"store_id":355,"project_name":"二七中原路全季","category_id":1194,"amount":29900,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:23","timeR":"15:31:23","type":20,"project_id":173,"memo":"11.13日付石材款"},{"store_id":355,"project_name":"桐柏全季","category_id":1194,"amount":57900,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:23","timeR":"15:31:23","type":20,"project_id":175,"memo":"11.13日付石材款"},{"store_name":"袁运涛","category_id":1197,"amount":62393,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:23","timeR":"15:31:23","type":20,"store_id":197,"memo":"11.14日付驻马店全季工地费用其他应付款"},{"store_id":182,"project_name":"新乡平原路汉庭","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:23","timeR":"15:31:23","type":20,"project_id":167,"memo":"11.14日付泥工施工款"},{"store_id":425,"project_name":"新乡平原路汉庭","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:23","timeR":"15:31:23","type":20,"project_id":167,"memo":"11.14日付木工施工款"},{"store_id":362,"project_name":"新乡平原路汉庭","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:23","timeR":"15:31:23","type":20,"project_id":167,"memo":"11.14日付油漆施工款"},{"store_id":362,"project_name":"方城汉庭","category_id":1194,"amount":80000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:24","timeR":"15:31:24","type":20,"project_id":115,"memo":"11.14日付油漆施工款"},{"store_id":451,"project_name":"方城汉庭","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:24","timeR":"15:31:24","type":20,"project_id":115,"memo":"11.14日付木工施工款"},{"store_id":477,"project_name":"方城汉庭","category_id":1194,"amount":85000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:24","timeR":"15:31:24","type":20,"project_id":115,"memo":"11.14日付水电施工款"},{"store_id":450,"project_name":"南阳你好","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:24","timeR":"15:31:24","type":20,"project_id":184,"memo":"11.14日付水电施工款"},{"store_id":425,"project_name":"南阳你好","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:24","timeR":"15:31:24","type":20,"project_id":184,"memo":"11.14日付木工施工款"},{"project_id":175,"category_id":1218,"amount":50000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:24","timeR":"15:31:24","type":20,"memo":"11.15日付王振业务费"},{"store_id":363,"project_name":"长垣汉庭","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":20,"project_id":181,"memo":"11.15日付门头施工款"},{"store_name":"崇岩","category_id":1197,"amount":1200,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":20,"store_id":468,"memo":"11.15日退开票款其他应付款","arap_id":347},{"store_id":233,"project_name":"高新区海友","category_id":1194,"amount":3000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":20,"project_id":169,"memo":"11.15日付邢亚东垃圾清运费"},{"store_id":229,"project_name":"洛阳美居","category_id":1194,"amount":10770,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":20,"project_id":182,"memo":"11.15日付李继远水泥大沙款"},{"store_id":233,"project_name":"高新区海友","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":20,"project_id":169,"memo":"11.15日付工地备用金"},{"store_name":"袁福君","category_id":1191,"amount":100000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":10,"store_id":23,"memo":"11.15日转袁总民生卡"},{"store_name":"袁福君","category_id":1191,"amount":6667.69,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:25","timeR":"15:31:25","type":10,"store_id":23,"memo":"11.16日信用卡还款"},{"project_id":185,"category_id":1235,"amount":6500,"account_id":70,"cate":"杂工工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:26","timeR":"15:31:26","type":20,"memo":"11.16日付袁留魁围挡费"},{"store_id":361,"project_name":"洛阳美居","category_id":1194,"amount":450000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:26","timeR":"15:31:26","type":20,"project_id":182,"memo":"11.17日付不锈钢款"},{"store_id":357,"project_name":"方城汉庭","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:26","timeR":"15:31:26","type":20,"project_id":115,"memo":"11.17日付弱电施工款"},{"store_name":"袁福君","category_id":1191,"amount":2636.73,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:26","timeR":"15:31:26","type":10,"store_id":23,"memo":"11.18日信用卡还款"},{"store_name":"洛阳中州西路全季装修押金","category_id":1191,"amount":20000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:26","timeR":"15:31:26","type":10,"store_id":478,"memo":"11.18日付装修押金"},{"store_name":"袁福君","category_id":1191,"amount":100000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:26","timeR":"15:31:26","type":10,"store_id":23,"memo":"11.18日转袁总民生卡"},{"project_id":114,"category_id":1602,"amount":44061,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":168,"category_id":1602,"amount":16391,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":168,"category_id":1601,"amount":21500,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":167,"category_id":1602,"amount":19161,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":167,"category_id":1601,"amount":32600,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":115,"category_id":1601,"amount":4200,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":175,"category_id":1601,"amount":26670,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:27","timeR":"15:31:27","type":20,"memo":"11.18日付材料款"},{"project_id":175,"category_id":1604,"amount":41064.70000000001,"account_id":70,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料款"},{"project_id":175,"category_id":1602,"amount":1688.3,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料款"},{"project_id":175,"category_id":1603,"amount":2352,"account_id":70,"cate":"木工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料款"},{"project_id":175,"category_id":1234,"amount":650,"account_id":70,"cate":"装卸运费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料运费"},{"project_id":173,"category_id":1649,"amount":19862,"account_id":70,"cate":"A采基装建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料款"},{"project_id":173,"category_id":1601,"amount":3040,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料款"},{"project_id":173,"category_id":1604,"amount":20901,"account_id":70,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:28","timeR":"15:31:28","type":20,"memo":"11.18日付材料款"},{"project_id":173,"category_id":1603,"amount":87442,"account_id":70,"cate":"木工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:29","timeR":"15:31:29","type":20,"memo":"11.18日付材料款"},{"project_id":173,"category_id":1601,"amount":11800,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:29","timeR":"15:31:29","type":20,"memo":"11.18日付材料款"},{"project_id":182,"category_id":1602,"amount":105403,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:29","timeR":"15:31:29","type":20,"memo":"11.18日付材料款"},{"project_id":182,"category_id":1234,"amount":3521,"account_id":70,"cate":"装卸运费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:29","timeR":"15:31:29","type":20,"memo":"11.18日付材料运费"},{"project_id":182,"category_id":1601,"amount":21000,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:29","timeR":"15:31:29","type":20,"memo":"11.18日付材料款"},{"project_id":182,"category_id":1603,"amount":356766,"account_id":70,"cate":"木工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:29","timeR":"15:31:29","type":20,"memo":"11.18日付材料款"},{"project_id":169,"category_id":1601,"amount":6204,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":20,"memo":"11.18日付材料款"},{"project_id":169,"category_id":1603,"amount":14109,"account_id":70,"cate":"木工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":20,"memo":"11.18日付材料款"},{"store_name":"袁福君","category_id":1191,"amount":60000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":10,"store_id":23,"memo":"11.19日转袁总民生卡"},{"category_id":1214,"amount":5000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":20,"memo":"11.20日ETC充值（豫AFG6135）"},{"project_id":164,"category_id":1218,"amount":30000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":20,"memo":"11.20日付马彪业务费（徐工）"},{"project_id":182,"category_id":1602,"amount":86240,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":20,"memo":"11.20日付材料款"},{"project_id":169,"category_id":1602,"amount":5280,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:30","timeR":"15:31:30","type":20,"memo":"11.20日付材料款"},{"project_id":180,"category_id":1602,"amount":2799,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:31","timeR":"15:31:31","type":20,"memo":"11.20日付材料款"},{"project_id":184,"category_id":1602,"amount":3849,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:31","timeR":"15:31:31","type":20,"memo":"11.20日付材料款"},{"project_id":168,"category_id":1602,"amount":14948,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:31","timeR":"15:31:31","type":20,"memo":"11.20日付材料款"},{"project_id":168,"category_id":1229,"amount":2281,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:31","timeR":"15:31:31","type":20,"memo":"11.20日付材料款"},{"project_id":168,"category_id":1602,"amount":364,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:31","timeR":"15:31:31","type":20,"memo":"11.20日付材料款"},{"project_id":168,"category_id":1601,"amount":1545,"account_id":70,"cate":"泥工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:32","timeR":"15:31:32","type":20,"memo":"11.20日付材料款"},{"project_id":167,"category_id":1604,"amount":1975,"account_id":70,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:32","timeR":"15:31:32","type":20,"memo":"11.20日付材料款"},{"project_id":167,"category_id":1229,"amount":860,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:32","timeR":"15:31:32","type":20,"memo":"11.20日付材料款"},{"project_id":180,"category_id":1229,"amount":1641,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:32","timeR":"15:31:32","type":20,"memo":"11.20日付材料款"},{"project_id":180,"category_id":1234,"amount":524,"account_id":70,"cate":"装卸运费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:32","timeR":"15:31:32","type":20,"memo":"11.20日付材料运费"},{"project_id":169,"category_id":1603,"amount":2030,"account_id":70,"cate":"木工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料款"},{"project_id":173,"category_id":1229,"amount":504,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料款"},{"project_id":173,"category_id":1234,"amount":3120,"account_id":70,"cate":"装卸运费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料运费"},{"project_id":113,"category_id":1229,"amount":1070,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料款"},{"project_id":115,"category_id":1229,"amount":2737,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料款"},{"project_id":115,"category_id":1649,"amount":1225,"account_id":70,"cate":"A采基装建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料款"},{"project_id":115,"category_id":1623,"amount":1826,"account_id":70,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:33","timeR":"15:31:33","type":20,"memo":"11.20日付材料款"},{"category_id":1219,"amount":267,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"memo":"11.20日付小蒋物流费"},{"store_id":431,"project_name":"高新区海友","category_id":1194,"amount":16000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"project_id":169,"memo":"11.20日付拆除施工款"},{"store_id":380,"project_name":"高新区海友","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"project_id":169,"memo":"11.20日付防水施工款"},{"category_id":1213,"amount":197,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"memo":"11.20日付小蒋车辆费餐费"},{"store_id":479,"project_name":"黄河路全季","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"project_id":180,"memo":"11.21日付工地备用金"},{"store_id":229,"project_name":"洛阳美居","category_id":1194,"amount":5850,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"project_id":182,"memo":"11.21日付梁超兵垃圾清运费"},{"store_id":380,"project_name":"南阳你好","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:34","timeR":"15:31:34","type":20,"project_id":184,"memo":"11.21日付防水施工款"},{"project_name":"桐柏全季","category_id":1194,"amount":4000000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":10,"project_id":175,"memo":"桐柏全季回款"},{"project_name":"方城汉庭","category_id":1194,"amount":800000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":10,"project_id":115,"memo":"方城汉庭回款"},{"project_name":"南阳漫心","category_id":1194,"amount":500000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":10,"project_id":114,"memo":"南阳漫心回款"},{"project_name":"新乡平原路汉庭","category_id":1194,"amount":300000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":10,"project_id":167,"memo":"新乡汉庭回款"},{"project_name":"长垣汉庭","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":10,"project_id":181,"memo":"长垣汉庭回款"},{"project_id":164,"category_id":1209,"amount":8940,"account_id":70,"cate":"办公费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":20,"memo":"11.21日付马彪打印图纸、快递费、鼠标键盘费"},{"project_id":164,"category_id":1242,"amount":600,"account_id":70,"cate":"培训学习费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":20,"memo":"11.21日付马彪上海培训报名费"},{"project_id":164,"category_id":1246,"amount":14160,"account_id":70,"cate":"外包设计费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:35","timeR":"15:31:35","type":20,"memo":"11.21日付马彪葫芦岛一二层施工图设计费"},{"project_id":164,"category_id":1213,"amount":19924,"account_id":70,"cate":"差旅费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.21日付马彪出差餐费、车辆费、招待费"},{"project_id":164,"category_id":1246,"amount":4500,"account_id":70,"cate":"外包设计费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.22日付王文霞叶县全季客房效果图设计费"},{"project_id":164,"category_id":1246,"amount":26900,"account_id":70,"cate":"外包设计费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.22日付王文霞桐柏全季效果图施工图设计费"},{"project_id":115,"category_id":1230,"amount":122,"account_id":70,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.22日付罗朋毫高铁费"},{"project_id":185,"category_id":1230,"amount":116.3,"account_id":70,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.22日付任蕊峰工地剪彩物品费"},{"project_id":169,"category_id":1216,"amount":21420,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.22日付胡天欣、史会芳、王党振、闫军海10月份小工工资"},{"project_id":115,"category_id":1216,"amount":14550,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:36","timeR":"15:31:36","type":20,"memo":"11.22日付周兰秀、梁六锋10月份小工工资"},{"store_id":362,"project_name":"桐柏全季","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":20,"project_id":175,"memo":"11.22日付油漆施工款"},{"store_id":161,"project_name":"桐柏全季","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":20,"project_id":175,"memo":"11.22日付美缝施工款"},{"store_id":200,"project_name":"二七中原路全季","category_id":1194,"amount":14400,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":20,"project_id":173,"memo":"11.22日付李淑权垃圾清运费"},{"store_id":362,"project_name":"高新区海友","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":20,"project_id":169,"memo":"11.22日付油漆施工款"},{"store_id":206,"project_name":"洛阳美居","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":20,"project_id":182,"memo":"11.22日付工地备用金"},{"store_name":"袁福君","category_id":1191,"amount":23125.9,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":10,"store_id":23,"memo":"11.23日信用卡全部还款"},{"project_id":175,"category_id":1218,"amount":260000,"account_id":70,"cate":"业务费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:37","timeR":"15:31:37","type":20,"memo":"11.24日付李洋桐柏全季业务费"},{"project_id":186,"category_id":1230,"amount":693,"account_id":70,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:38","timeR":"15:31:38","type":20,"memo":"11.24日付王进有工地水电费材料费"},{"store_id":361,"project_name":"二七中原路全季","category_id":1194,"amount":220000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:38","timeR":"15:31:38","type":20,"project_id":173,"memo":"11.24日付不锈钢款"},{"store_id":480,"project_name":"二七中原路全季","category_id":1194,"amount":100000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:38","timeR":"15:31:38","type":20,"project_id":173,"memo":"11.24日付门头字招施工款"},{"project_id":114,"category_id":1603,"amount":3439,"account_id":70,"cate":"木工材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:38","timeR":"15:31:38","type":20,"memo":"11.24日付材料款"},{"project_id":114,"category_id":1229,"amount":2585.5,"account_id":70,"cate":"施工措施材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:38","timeR":"15:31:38","type":20,"memo":"11.24日付材料款"},{"project_id":114,"category_id":1649,"amount":14590,"account_id":70,"cate":"A采基装建材","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:38","timeR":"15:31:38","type":20,"memo":"11.25日付材料款"},{"project_id":114,"category_id":1610,"amount":1800,"account_id":70,"cate":"A采电器家电","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.26日付材料款"},{"project_id":114,"category_id":1650,"amount":1000,"account_id":70,"cate":"A采布草","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.27日付材料款"},{"project_id":114,"category_id":1651,"amount":1070,"account_id":70,"cate":"A采小项办公用品","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.28日付材料款"},{"project_id":114,"category_id":1623,"amount":16999.5,"account_id":70,"cate":"基装A采电气件","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.24日付材料款"},{"project_id":173,"category_id":1604,"amount":22546.63,"account_id":70,"cate":"供排水材料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.24日付材料款"},{"project_id":173,"category_id":1602,"amount":7856.37,"account_id":70,"cate":"电器电料","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.24日付材料款"},{"project_id":173,"category_id":1230,"amount":3600,"account_id":70,"cate":"施工管理费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:39","timeR":"15:31:39","type":20,"memo":"11.24日付板房费"},{"project_id":173,"category_id":1234,"amount":6550,"account_id":70,"cate":"装卸运费","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"memo":"11.24日付吊车费、材料运费"},{"project_id":175,"category_id":1216,"amount":14760,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"memo":"11.24日付彭运庭、史建明、任东江10月份小工工资"},{"store_id":448,"project_name":"桐柏全季","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"project_id":175,"memo":"11.24日付钢结构施工款"},{"project_id":184,"category_id":1216,"amount":2430,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"memo":"11.24日付孟庆辉、胡天欣10月份小工工资"},{"project_id":164,"category_id":1216,"amount":2000,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"memo":"11.24日付焦佳设计办公室费用"},{"store_id":425,"project_name":"南阳你好","category_id":1194,"amount":50000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"project_id":184,"memo":"11.25日付木工施工款"},{"store_id":202,"project_name":"桐柏全季","category_id":1194,"amount":33370,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:40","timeR":"15:31:40","type":20,"project_id":175,"memo":"11.25日付工地备用金"},{"store_id":481,"project_name":"南阳你好","category_id":1194,"amount":31400,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:41","timeR":"15:31:41","type":20,"project_id":184,"memo":"11.25日付拆除施工款"},{"store_id":430,"project_name":"南阳你好","category_id":1194,"amount":30000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:41","timeR":"15:31:41","type":20,"project_id":184,"memo":"11.25日付泥工施工款"},{"store_id":379,"project_name":"洛阳美居","category_id":1194,"amount":30000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:41","timeR":"15:31:41","type":20,"project_id":182,"memo":"11.25日付美缝施工款"},{"store_id":380,"project_name":"洛阳美居","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:41","timeR":"15:31:41","type":20,"project_id":182,"memo":"11.25日付防水施工款"},{"store_id":422,"project_name":"洛阳美居","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:41","timeR":"15:31:41","type":20,"project_id":182,"memo":"11.25日付自流平施工款"},{"project_id":182,"category_id":1216,"amount":36315,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:41","timeR":"15:31:41","type":20,"memo":"11.25日付10月份小工工资"},{"store_id":212,"project_name":"二七中原路全季","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":20,"project_id":173,"memo":"11.25日付工地备用金"},{"store_id":452,"project_name":"二七中原路全季","category_id":1194,"amount":2300,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":20,"project_id":173,"memo":"11.25日付围挡施工款"},{"store_id":161,"project_name":"二七中原路全季","category_id":1194,"amount":35000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":20,"project_id":173,"memo":"11.25日付美缝施工款"},{"store_id":198,"project_name":"中牟上东里全季","category_id":1194,"amount":8400,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":20,"project_id":168,"memo":"11.27日付侯帅垃圾清运费"},{"project_id":168,"category_id":1216,"amount":23736,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":20,"memo":"11.27日付程相谦、李新军、李福现、李金升、王张轩10月份小工工资"},{"store_name":"袁福君","category_id":1191,"amount":10000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":10,"store_id":23,"memo":"11.27日转袁总民生卡"},{"store_id":482,"project_name":"洛阳美居","category_id":1194,"amount":63400,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:42","timeR":"15:31:42","type":20,"project_id":182,"memo":"11.29日付方管款"},{"store_name":"王进有","category_id":1197,"amount":6085,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"store_id":199,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"马静","category_id":1197,"amount":10500,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"store_id":205,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"蒋旭焱","category_id":1197,"amount":23000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"store_id":475,"memo":"11.29日付10月份工资其他应付款"},{"store_name":"王文霞","category_id":1197,"amount":22000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"store_id":240,"memo":"11.29日付10月份工资其他应付款"},{"store_id":483,"project_name":"洛阳美居","category_id":1194,"amount":25419,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"project_id":182,"memo":"11.29日付瓷砖款"},{"category_id":1213,"amount":25.26,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"memo":"11.30日付高亮出差报销费用"},{"category_id":1244,"amount":248.9,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:43","timeR":"15:31:43","type":20,"memo":"11.30日付齐总招待费"},{"store_id":380,"project_name":"中牟上东里全季","category_id":1194,"amount":40000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:44","timeR":"15:31:44","type":20,"project_id":168,"memo":"11.30日付防水施工款"},{"store_id":380,"project_name":"桐柏全季","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:44","timeR":"15:31:44","type":20,"project_id":175,"memo":"11.30日付防水施工款"},{"store_id":370,"project_name":"南阳漫心","category_id":1194,"amount":12400,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:44","timeR":"15:31:44","type":20,"project_id":114,"memo":"11.30日付木地板施工款"},{"store_id":67,"project_name":"新乡平原路汉庭","category_id":1194,"amount":30000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:44","timeR":"15:31:44","type":20,"project_id":167,"memo":"11.30日付壁纸施工款"},{"store_id":484,"project_name":"新乡平原路汉庭","category_id":1194,"amount":16900,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:44","timeR":"15:31:44","type":20,"project_id":167,"memo":"11.30日付拆除施工款"},{"store_id":362,"project_name":"南阳漫心","category_id":1194,"amount":11000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:44","timeR":"15:31:44","type":20,"project_id":114,"memo":"11.30日付卫生间找平施工款"},{"store_id":67,"project_name":"南阳漫心","category_id":1194,"amount":20000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":20,"project_id":114,"memo":"11.30日付壁布施工款"},{"project_id":167,"category_id":1216,"amount":18195,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":20,"memo":"11.30日付陈鹏、王长营、王敏10月份小工工资"},{"store_id":229,"project_name":"洛阳美居","category_id":1194,"amount":4500,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":20,"project_id":182,"memo":"11.30日付梁超兵垃圾清运费"},{"store_id":197,"project_name":"南阳你好","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":20,"project_id":184,"memo":"11.30日付工地备用金"},{"project_id":173,"category_id":1216,"amount":21960,"account_id":70,"cate":"工资","dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":20,"memo":"11.30日付李利杰、李留福、孙福德、万山听10月份小工工资"},{"store_id":161,"project_name":"桐柏全季","category_id":1194,"amount":10000,"account_id":70,"dateR":"2023-10-31","is_yushou":true,"tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":20,"project_id":175,"memo":"11.30日付美缝施工款"},{"store_name":"星程酒店","category_id":1191,"amount":200000,"account_id":70,"dateR":"2023-10-31","tally_id":59,"tally_time":"2023-10-31 15:31:45","timeR":"15:31:45","type":10,"store_id":485,"memo":"11.30日转星程酒店"}]';

        $json_data = json_decode($str,JSON_UNESCAPED_UNICODE);

        foreach ($json_data as &$value){
                if($value['account_id'] == null){
                    $value['account_id'] = 83;
                }
        }
        foreach ($json_data as &$value){
            $value['dateR'] = $dateR;
            $value['timeR'] = $timeR;
            $value['tally_time'] = $tally_time;
            if($value['amount'] < 0){
                $value['amount'] = -($value['amount']);
            }
        }
//        var_dump($json_data);
        $connection = Yii::$app->db->beginTransaction();
        try {
            foreach ($json_data as $key=> $postData){
                $form = DynamicModel::validateData([
                    'tally_id'      => $postData['tally_id'], //账本id
                    'category_id'   => $postData['category_id'] ?: 0,//分类
                    'arap_id'       => $postData['arap_id'] ?: 0,// 应收应付ID
                    'future_id'       => $postData['future_id'] ?: 0,// 应收应付ID
                    'account_id'    => $postData['account_id'] ?: 0, //账户
                    'account_dst_id'  => $postData['account_dst_id'] ?: 0, //目标账户
                    'amount'        => $postData['amount'], // 金额
                    'project_id'    => $postData['project_id'] ?: 0, // 项目
                    'store_id'      => $postData['store_id'] ?: 0, // 商家
                    'member_id'     => $postData['member_id'] ?: 0, // 成员
                    'tally_time'    => $postData['tally_time'], // 账单时间
                    'is_gua'    => $postData['is_gua'], // 账单时间
                    'is_yushou'    => $postData['is_yushou'], // 账单时间
                    'uid'   => 9,
                    'type'  => $postData['type'],
                    'memo'  => $postData['memo'],
                    'attachment'  => '',//附件 多个逗号分隔
                    'state' => 1, // 默认状态
                ],[
                    [['tally_id','account_id','amount','tally_time','type'], 'required'],
                    ['type', 'in', 'range' => [TallyRecord::TYPE_IN, TallyRecord::TYPE_OUT, TallyRecord::TYPE_TRANS]],
                    ['memo', 'trim'],
                ]);


                if( !$form->arap_id && ($form->is_gua == 1 || in_array( $form->category_id, TallyCategory::$gzIds))) {
                    // 执行挂账操作 不用统计金额 只需要入挂账库即可
                    $result = TallyArapService::create(ArrayHelper::toArray($form));
                    //失败
                    if($result === false){
                        return self::failureResponse();
                    }
                    continue;
                }
                $result = TallyRecordService::create(ArrayHelper::toArray($form));
                if(!$result){
                    throw new Exception(TallyService::getError());
                }
                // 这里对状态进行拦截 只有状态正常的才要进入账户金额统计
                if( $form->state == TallyRecord::STATE_VALID){
                    TallyRecordService::calRelationAmount($form);
                    // 如果涉及挂账操作 进行挂账金额重新核算
                    if($form->arap_id) {
                        TallyArapService::calRelationAmount($form->arap_id);
                    }
                }
                //添加预收表格数据
                if(!$form->future_id && $form->is_yushou){
                    $formData = ArrayHelper::toArray($form);
                    $formData['tally_record_id'] = $result;
                    $result = TallyFutureServices::create($formData);
                    if(!$result){
                        throw new Exception(TallyService::getError());
                    }
                }
                // 触发账单记录事件
                $this->triggerEvents([
                    'tally_id' => $form->tally_id,
                    'uid'   => $form->uid,
                    'type'  => 2,
                    'content' => '添加账单,id:'.$result.',金额:'.$form->amount,
                ]);
            }

            $connection->commit();
            return self::successResponse();

        }catch (\Exception $exception){
            $connection->rollBack();
            return  self::failureResponse('',$exception->getMessage());
        }

    }


    /**
     * @throws \Exception
     */
    public function actionNoticePay(){
        require dirname(dirname(dirname ( dirname(dirname(__FILE__)) )))."/extra/alipay/pagepay/service/AlipayTradeService.php";
        $orderNo = $_POST['out_trade_no'];
        $test_content = new TestContent();
        $test_content->load([
            'content'=>$orderNo
        ],'');
        $test_content->save();
        //支付成功
        $vip_order_info = TallyVipOrder::find()->where([
            'vip_order_code'=>$orderNo,
            'status'=>0
        ])->one();
        if(!$vip_order_info){

            echo 'error';exit;
        }

        $vip_order_info->status = 1;
        $vip_order_info->save();
        $express = ($vip_order_info['vip_days']) * 86400;
        $tally_info = Tally::find()->where([
            'id'=>$vip_order_info['tally_id']
        ])->one();
        if($vip_order_info['vip_days'] > 10000){
            $express = strtotime('2099-12-31');
            $tally_info->express_time = $express;
            $tally_info->save();
        }else{
            $tally_info->updateCounters(['express_time'=>$express]);
        }
        echo 'success';
    }


    public function actionTestApi(){
        $datas=  [];
        $day = 365;
        for($a=1;$a<=499;$a++){
                $len = 9;

                 $chars = "abcdefghijklmnopqrstuvwxyz0123456789";
                mt_srand(10000000*(double)microtime());
                for ($i = 0, $str = '', $lc = strlen($chars)-1; $i < $len; $i++){
                    $str .= $chars[mt_rand(0, $lc)];
                }
            $datas[] = $str;

        }
        $arr = array_unique($datas);
        $inser = [];
        $model = new AppSerial();
        $transaction=Yii::$app->db->beginTransaction();
        try {
            foreach ($arr as $key=>$value){
                $day = 30*365;


                $_model = clone $model;
                $_model->serial_account = '2312'.str_pad($key+9501,4,'0',STR_PAD_LEFT);
                $_model->serial_number = $value;
                $_model->days = $day;
//                $_model->save();
            }

            $transaction->commit();
        }catch (\Exception $exception){
            $transaction->rollBack();
        }



    }

    /**
     * @return array
     * @生成图形验证码
     */
    public function actions(){
        return [
            'captcha' => [
                'class' => 'yii\captcha\CaptchaAction',
                'width' => 80,
                'height' => 30,
                'padding' => 0,
                'maxLength' => 4,
                'minLength' => 4,
                'offset' => 2,
            ]
        ];
    }

    /**
     * @throws
     * 注册
     */
    public function actionRegister()
    {
        $formData   = Yii::$app->request->post();
        $inputCode  = ArrayHelper::getValue($formData,'code');
        $phone      = ArrayHelper::getValue($formData,'mobile');
        $username      = ArrayHelper::getValue($formData,'username');
        $authCode      = ArrayHelper::getValue($formData,'auth_code',''); // 授权码
        if(!$phone) {
            return self::failureResponse(500,'参数校验失败');
        }
        if(!$inputCode) {
            return self::failureResponse(500,'请输入验证码');
        }
        if(!$username) {
            return self::failureResponse(500,'请输入姓名');
        }
        // 判断验证码是否有效
        if(!CommonService::checkSmsCode($phone,$inputCode)) {
            return self::failureResponse(500,'验证码校验失败');
        }

        // 授权码校验
        $domainAlias = DomainExtraConfigService::getVal('alias');
        if(in_array($domainAlias,DomainExtraConfigService::$needAuthDomainAlias)) {
            if(!$authCode) {
                return self::failureResponse(500,'请输入授权码');
            }
            if(!DomainAuthService::checkValid($domainAlias,$authCode)) {
                return self::failureResponse(500,'授权码不存在或已被使用');
            }
        }

        $insertUid     = UserService::register($formData);
        if ($insertUid) {
            // 用户注册成功事件 写入异步队列处理
            Yii::$app->queue->push(new NewUserJob([
                'uid' => $insertUid,
            ]));

            // 更新授权码状态
            DomainAuthService::setUsed($domainAlias,$authCode,$insertUid);

            if( ArrayHelper::getValue($formData,'autologin') ) {
                // 自动登录逻辑
                $token  = ToolService::createUuid();
                // token 存入redis
                UserService::storeLoginToken($token,$insertUid);
                $retData = [
                    'phone' => $phone,
                    'username' =>  $username,
                    'token' => $token
                ];
                return self::successResponse($retData);
            }
            return self::successResponse();
        }else{
            return self::failureResponse(500,UserService::getError());
        }
    }

    public function actionLogincode(){

    }


    public function actionSettings(){
        $datas = SysSetting::find()->all();
        $settings = [];
        foreach ($datas as $key=>$value){
            $settings[ $value['s_key']] = $value['s_value'];
        }
        $settings['android_url'] = 'https://static.gongsizhang.com/app/app-release123.apk';
        $settings['ANDROID_APP_VERSION'] = '1.2.3';
        return self::successResponse($settings);
    }

    /**
     * @throws
     * 用户登录 兼容密码登录&验证码登录
     */
    public function actionLogin()
    {
        $formData   = Yii::$app->request->post();
        if(!ArrayHelper::getValue($formData,'username')) {
            return self::failureResponse(500,'登录账号不能为空');
        }
        if(!ArrayHelper::getValue($formData,'sms_code')) {
            $result     = UserService::loginByMobile($formData);
        }else{
            // 检测短信验证码是否一致
            if(!CommonService::checkSmsCode($formData['username'],$formData['sms_code'])) {
                return self::failureResponse(500,'验证码校验失败');
            }
            // 用户手机号不存在的话 这种情况进行快速注册 然后再调用登录接口
            $userModel = User::findByUsername($formData['username']);
            if(!$userModel){
                $pass = substr($formData['username'],-6,6);
                // 进行用户的快速注册
                $insertUid     = UserService::register([
                    'mobile' => $formData['username'],
                    'password' => $pass,
                    'password2' => $pass,
                ]);
                if($insertUid){
                    // 用户注册成功事件 写入异步队列处理
                    Yii::$app->queue->push(new NewUserJob([
                        'uid' => $insertUid,
                    ]));
                    // 注册成功 调用登录接口返回
                    $result     = UserService::loginByCode($formData);
                }else{
                    // 返回注册失败
                    return self::failureResponse(500,UserService::getError());
                }
            }else{
                $result     = UserService::loginByCode($formData);
            }
        }
        if ($result) {
            $token  = ToolService::createUuid();
            // token 存入redis
            UserService::storeLoginToken($token,Yii::$app->user->identity->id);
            $retData = [
                'phone' => Yii::$app->user->identity->mobile,
                'username' =>  Yii::$app->user->identity->username,
                'token' => $token
            ];
            return self::successResponse($retData);
        }else{
            return self::failureResponse(500,UserService::getError());
        }
    }

    /**
     * @throws
     * 忘记密码功能
     */
    public function actionForgetPassword()
    {
        $formData = Yii::$app->request->post();
        $form = DynamicModel::validateData([
            'phone' => ArrayHelper::getValue($formData,'phone'),
            'sms_code' => ArrayHelper::getValue($formData,'sms_code'),
            'password' => ArrayHelper::getValue($formData,'password'),
            'password2' => ArrayHelper::getValue($formData,'password2'),
        ],[
            [['phone','sms_code','password','password2'], 'required'],
            ['password2', 'compare','compareAttribute'=>'password'],
        ]);
        if ($form->hasErrors()) {
            return self::failureResponse(500,current($form->getFirstErrors()));
        }
        // 进行密码重置
        $userModel = User::findByUsername($form->phone);
        if(!$userModel) {
            return self::failureResponse(500,'该账户不存在');
        }
        // 进行密码重置
        $userModel->password_hash = Yii::$app->security->generatePasswordHash($form->password);
        $result = $userModel->save();
        if($result) {
            return self::successResponse();
        }else{
            return self::failureResponse(500,'设置密码失败;'.current($userModel->getFirstErrors()));
        }
    }

    /**
     * 设置频次
     * @param $mobile
     *
     * @throws \yii\base\InvalidConfigException
     */
    protected function setRate($mobile)
    {
        $userIp = Yii::$app->request->userIP;
        $ipLong = ip2long($userIp);
        $redis = Yii::$app->get('redis');
        $day = date('Ymd');
        $phoneRateKey = 'Rate:'.$day.'_.'.$mobile;
        $ipRateKey = 'Rate:'.$day.'_.'.$ipLong;
        // 频次自增+1
        $redis->incr($phoneRateKey);
        $redis->incr($ipRateKey);
        // 设置过期时长
        $redis->expire($phoneRateKey,3600*24);
        $redis->expire($ipRateKey,3600*24);
    }

    /**
     * 检查短信发送频次
     * @param $mobile
     *
     * @return bool
     * @throws \yii\base\InvalidConfigException
     */
    protected function checkRate($mobile)
    {
        $userIp = Yii::$app->request->userIP;
        $ipLong = ip2long($userIp);
        $redis = Yii::$app->get('redis');
        $day = date('Ymd');
        $phoneRate = intval( $redis->get('Rate:'.$day.'_'.$mobile) );
        $ipRate = intval( $redis->get('Rate:'.$day.'_'.$ipLong) );
        if($phoneRate > 10 || $ipRate > 10 ){
            return false ;
        }else{
            return true ;
        }
    }

    /**
     * @throws
     * 发送短信验证码
     */
    public function actionSms()
    {
        $phone = Yii::$app->getRequest()->post('phone');
        $verify = Yii::$app->getRequest()->post('verify');
        if ($verify && !$this->createAction('captcha')->validate($verify, false)) {
            return self::failureResponse(500,'图形验证码错误');
        }
        if(!$phone) {
            return self::failureResponse(500,'缺少手机号参数');
        }
        if(!ToolService::checkMobile($phone)) {
            return self::failureResponse(500,'手机号格式不正确');
        }
        // 进行频次验证同一手机号一天10次/同一IP一天最多10次触发
        if(!$this->checkRate($phone)){
            return self::failureResponse(500,'请求太频繁啦');
        }
        $code    = rand(100000, 999999);
//        $content = '您本次验证码为'.$code.'，5分钟内有效';
        if(YII_ENV == 'dev') {
            $code = '666666'; // 测试环境固定验证码
            // 验证码写入redis
            Yii::$app->get('redis')->setex('Sms:'.$phone,600,$code);
            return self::successResponse(['code'=>$code]);
        }
        try {
            // 发短信
//            $sendRes = ToolService::sendSms($phone,$content);
            $templateId = '984759'; // 腾讯云短信模板ID
            $sender = new SmsSingleSender(getenv('QCLOUD_SMS_APPID'), getenv('QCLOUD_SMS_APPKEY'));
            $codeParams = [$code];
            $sendResult = $sender->sendWithParam("86", $phone, $templateId,
                $codeParams, '公司账');
            $sendResult = json_decode($sendResult,true);
            if($sendResult['result'] == 0 ){
                $sendRes = true; // 发送完毕
            }else{
                $sendRes = false;
            }
            if($sendRes) {
                // 验证码写入redis
                Yii::$app->get('redis')->setex('Sms:'.$phone,600,$code);
                // 写入频次
                $this->setRate($phone);
                return self::successResponse();
            }else{
                return self::failureResponse(500,'短信服务异常.');
            }
        } catch(\Exception $e) {
            return self::failureResponse('500','发送失败:'.$e->getMessage());
        }
    }

    /**
     * @throws \yii\base\ExitException
     * @desc 根据手机号判定用户是否存在
     */
    public function actionUserExist()
    {
        $phone = Yii::$app->getRequest()->get('phone');
        if(!$phone) {
            return self::failureResponse(500,'缺少手机号参数');
        }
        $info = UserService::getUserByPhone($phone);
        if(!$info) {
            return self::failureResponse(1018,'用户不存在');
        }else{
            return self::successResponse();
        }
    }
}
